/*
 Navicat Premium Data Transfer

 Source Server         : ali-mysql
 Source Server Type    : MySQL
 Source Server Version : 80026
 Source Host           : 39.107.92.215:3306
 Source Schema         : mall-sys

 Target Server Type    : MySQL
 Target Server Version : 80026
 File Encoding         : 65001

 Date: 08/11/2021 15:31:56
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for tb_user
-- ----------------------------
DROP TABLE IF EXISTS `tb_user`;
CREATE TABLE `tb_user` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `username` varchar(32) NOT NULL COMMENT '用户名',
  `password` varchar(32) NOT NULL COMMENT '密码，加密存储',
  `phone` varchar(11) DEFAULT NULL COMMENT '注册手机号',
  `created` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `salt` varchar(32) NOT NULL COMMENT '密码加密的salt值',
  `point` int DEFAULT '0' COMMENT '用户下单的积分',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb3 COMMENT='用户表';

-- ----------------------------
-- Records of tb_user
-- ----------------------------
BEGIN;
INSERT INTO `tb_user` VALUES (28, 'zhangsan', 'e21d44f200365b57fab2641cd31226d4', '13600527634', '2021-10-22 17:36:33', '05b0f203987e49d2b72b20b95e0e57d9', 0);
INSERT INTO `tb_user` VALUES (30, 'leyou', '4de9a93b3f95d468874a3c1bf3b25a48', '15855410440', '2021-10-22 17:36:35', '4565613d4b0e434cb496d4eb87feb45f', 0);
INSERT INTO `tb_user` VALUES (31, 'sunbaifeng', 'a142f2a1935d225c1a6afd1e4adf06ce', '12345678', '2021-10-23 01:47:46', '5dc1fe74a13b4e3aaeddbf1e5ae9c349', NULL);
INSERT INTO `tb_user` VALUES (32, 'su', '65b8ec7f45569147db6bcba35f52f45f', '12345678', '2021-10-23 02:33:56', '248a3ce8ff834d21a121998eebfc39aa', NULL);
INSERT INTO `tb_user` VALUES (33, 'su1', 'dd640c46696043324fb30664aeaa64ee', '12345678', '2021-10-23 02:35:29', '88a46e960d584bb092a9bdfeeabdd7a6', NULL);
INSERT INTO `tb_user` VALUES (34, 'zhaolei', '94244f3d2bd7f2e908b7d174d6dfe8d8', '12345678', '2021-10-23 02:59:48', '58fbac1a339b475b9dbea338f8136bfb', NULL);
INSERT INTO `tb_user` VALUES (35, 'shenweilong', 'c18e09cb5089e8c8b0292b59c214ba62', '12345678', '2021-10-23 13:33:37', '5931703775c048c5a4be9ccfefe2df4e', NULL);
INSERT INTO `tb_user` VALUES (36, 'maijinzhi', '6e03d02b1b3c8b3ca90712cc392b1b8d', '12345678', '2021-10-23 13:35:30', 'c411655086c64fe39a168ba53f6cef12', NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
